09/09/2021

Introduction

Jonathan

The Team

  • Derek - Life Expectancy SME
  • John Paul - Smoking SME
  • JP - Drug Abuse SME
  • Prathiba - R Shiny Dashboard Architect
  • Paddy - Spatial Data Guru

Key findings - Life expectancy

Derek

The Data

  • What is life expectancy and why it was chosen?

Life expectancy is a statistical measure of the average time an organism is expected to live, based on the year of its birth, its current age and any other demographic factors including sex and geographic area.

  • The source of the data

statistics.gov.uk

  • Why was this data selected?

Trend - Dumfries & Galloway

Trend - Scotland

Rank - Local Authority

Key Findings

  • In Scotland in 2017-2019, the life expectancy at birth was 77.1 years for males, and 81.1 years for females.
  • Life expectancy since 1991-1993 has increased but has largely remained unchanged since 2013-2015.
  • Female life expectancy is lowest at birth in Glasgow (78.5 years) and highest in East Renfrewshire (84 years).
  • Male life expectancy is lowest at birth in Glasgow (73.6 years) and highest in East Dunbartonshire (80.5 years).
  • The majority of Scotland’s council areas have seen a slow down in life expectancy since 2013-2015, with some seeing a decrease.

Key findings - Smoking

John Paul

The data

  • The data set used for this was: Smoking - Scottish Survey Core Questions

  • The data was sourced from: statistics.gov.uk

  • Why it was chosen We chose Smoking as two of the Scottish Government’s National Performance Framework (NPF) National Indicators are relevant to smoking.

There is a strong Public Health focus on reducing the proportion of adults who smoke.

Trend

The overview is optimistic.

Whilst numbers are still higher than anyone would like, the long term trend shows a steady reduction in all age groups.

Rank

In some areas you are 300% more likely to smoke than in other areas.

Rank - continued

Where you live dictates how likely you are to smoke.

Map

There are huge variations around the country, whether they be measured by NHS Health Board or the more granular Local Authority areas.

Essentially the areas with the lowest proportion of smokers are more affluent. The opposite is also true.

  • Findings

More work needs to be in less affluent areas to further reduce the rate of smoking.

Key findings - Drug abuse

Jonathan

The data

  • Scottish Drug Misuse Database
  • https://www.opendata.nhs.scot/
  • Published by Public Health Scotland - the national public health body for Scotland
  • Why was this data selected?

Trend by gender

Trend by age group

Rank

Dashboard Demonstration

Prathiba & Paddy

Questions